UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qvTv5RO1CSAVuJ9pz5lo1ZtFshPNkJkf7DvwHPnr5W8='
WHERE
key_id = 'c8740311fdf3d1e775d136a08c54b49a2caa113b86b5b2941db0c81a39b0f617'
AND (
token = 'qvTv5RO1CSAVuJ9pz5lo1ZtFshPNkJkf7DvwHPnr5W8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)