UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NX6ZnZRbvEUE5RRtgYjoub+R3a4sTuPkxmVaFBptNek='
WHERE
key_id = 'a640ef53c8d6afba61ba9937914eed88e29dda81ed0d643f27d94a1aba36725b'
AND (
token = 'NX6ZnZRbvEUE5RRtgYjoub+R3a4sTuPkxmVaFBptNek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)