UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bXX4ULRENN8X+AYiPBkSCUc4X/O9YJKakA1yJZETFH4='
WHERE
key_id = '64108b8fef16e8445bf6ca92341647dd2aa91e3c9222bdf89ae7afafba5b0dcf'
AND (
token = 'bXX4ULRENN8X+AYiPBkSCUc4X/O9YJKakA1yJZETFH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)