UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RmgbyYNHdHq28M7VayN/bvutg98vxHlLohN0+mBw+NI='
WHERE
key_id = 'd195ee0d1586904eea9dd998ae3ebea6dbeb5e450e0187a245fcf52e86cae79d'
AND (
token = 'RmgbyYNHdHq28M7VayN/bvutg98vxHlLohN0+mBw+NI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)