UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'csqSWjgIBLwIak49tqX4fm67PZKs1AgxOxRxWntEgTc='
WHERE
key_id = '77bcbca38d2a7aac4cf73844d0294dbace0ba1a0e62d070137d9060888ef2f0e'
AND (
token = 'csqSWjgIBLwIak49tqX4fm67PZKs1AgxOxRxWntEgTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)