UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+QgAZ4hRr+aevp7G/rVJpbYDs/TZ3Og7t2UakczE5V8='
WHERE
key_id = '505eb8dfb4317308fdd28813de08ede6a59d3f00e98b145efc4d35dd71dcb48f'
AND (
token = '+QgAZ4hRr+aevp7G/rVJpbYDs/TZ3Og7t2UakczE5V8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)