UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TheJIgAIIw9Y1W2RvulSzcQxxNd0E8pobFTGQTRUvjE='
WHERE
key_id = '308291a0f0b87ce84bd1a58a459fbbe35a8fce3277719d5448f5388f6411c745'
AND (
token = 'TheJIgAIIw9Y1W2RvulSzcQxxNd0E8pobFTGQTRUvjE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)