UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B+7T0tcaLsid0lmHWvoUVb6DM9m41oArIVfSEjM4Ln0='
WHERE
key_id = '2dd3703d5be713b5e69a839aba111c2f34fcea95d8b46da89618838d6aa4ab8e'
AND (
token = 'B+7T0tcaLsid0lmHWvoUVb6DM9m41oArIVfSEjM4Ln0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)