UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GjARLYIC29ObN3MN5KW7bPkm/rIwXM4OnOOvxl13rn4='
WHERE
key_id = '1d166b7e4650a6d190a6ca18867e1f8a5fde5b49f365d157560b2ba9ef69b430'
AND (
token = 'GjARLYIC29ObN3MN5KW7bPkm/rIwXM4OnOOvxl13rn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)