UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0WQyMqFmSHDgU0n6J5EdGbLlr8sj/FSl8tVUUowa+xU='
WHERE
key_id = 'af07b5b59b66ab54727622dad950352dba55ff657497541f67705d998974eb3a'
AND (
token = '0WQyMqFmSHDgU0n6J5EdGbLlr8sj/FSl8tVUUowa+xU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)