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