UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/1QuxWMMYgYl28pwTz/Yk6mXQZIP8aBtH9fQiDR5tBQ='
WHERE
key_id = '42d7d14fa0c50ef2edb35a8a2657f7bb740d0607d1849b33c356a7def3ead229'
AND (
token = '/1QuxWMMYgYl28pwTz/Yk6mXQZIP8aBtH9fQiDR5tBQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)