UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZSd989P+XYvjrbGf73rbV3TkA77Lhm1TlqFjV48XhA='
WHERE
key_id = '1e94a8a270fbe61bc903b400b6ae54c2bede74469d3e9fcc3047b690989338a3'
AND (
token = '2ZSd989P+XYvjrbGf73rbV3TkA77Lhm1TlqFjV48XhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)