UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dy0XyOEIiSz7mVZNTVfs8GvjZOsrXzUyBgvZVUEHkA='
WHERE
key_id = '053f42e141525e37f87b3adc30ba211d3efe25f1528e9848441bb2dbf2a37d01'
AND (
token = '0dy0XyOEIiSz7mVZNTVfs8GvjZOsrXzUyBgvZVUEHkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)