UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'up/d9inxGqtFQAoVsqSXSdmzzFMgShTuZt6lCW4RFjQ='
WHERE
key_id = '7ac9f1809cedea71f1670e1488b6ba8d35bdae389598417279858712b95a3f53'
AND (
token = 'up/d9inxGqtFQAoVsqSXSdmzzFMgShTuZt6lCW4RFjQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)