UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W5v0JVByVDBHinl/8Pm3wL2UQp2anI52RKmIZaovk+c='
WHERE
key_id = 'ace76b2432b089e1a4ae3ed631338088fc61f0eb98db23e283e438ea317af9d2'
AND (
token = 'W5v0JVByVDBHinl/8Pm3wL2UQp2anI52RKmIZaovk+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)