UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ynVpSPjtKUAapKcX8e5kXiX1M34RRP9+tx9au4ypBC8='
WHERE
key_id = 'b53f1f4548c3f72c7245d33f0cfddde084034c50702dc000b034f5786836c9f0'
AND (
token = 'ynVpSPjtKUAapKcX8e5kXiX1M34RRP9+tx9au4ypBC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)