UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lApSbGJxc5I1LOg0stALDgU7pyb3d2x4OoJ42RheGg='
WHERE
key_id = 'bd1c550a7c6049ce504a66dd2ad0eaec828a6d6fa25532545bf090951b308540'
AND (
token = '/lApSbGJxc5I1LOg0stALDgU7pyb3d2x4OoJ42RheGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)