UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BqCwGqfXs8amnCyPUVE9uf/29XYrZ4n7KVXSy9aVaSg='
WHERE
key_id = '807d31707bef53904ea4034449bdb762b12adeb0411dfea9c76a2fb15ce3bbe7'
AND (
token = 'BqCwGqfXs8amnCyPUVE9uf/29XYrZ4n7KVXSy9aVaSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)