UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpQSq8M2PDKq3psmGjHdmmunzeuWSjkz9JutPAIY83o='
WHERE
key_id = '31cb1dc1f863ed72a8d326148d08691cd28abcff09e04656d4ea0c5797816360'
AND (
token = 'hpQSq8M2PDKq3psmGjHdmmunzeuWSjkz9JutPAIY83o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)