UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'irLqe5pUQ8DDbOu9y6DiEHZotB8yw8ss9gJZgTTW3nI='
WHERE
key_id = 'a6e93787759a4ab118d79370e67fc71ed6743b4c7766932c132389b660115365'
AND (
token = 'irLqe5pUQ8DDbOu9y6DiEHZotB8yw8ss9gJZgTTW3nI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)