UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'waTGHEIw4kr8SIrO1+x0eny34fNwKmMp9JTo8FRu6gA='
WHERE
key_id = '6fbfc444a4c03ec4c4ac7b72e07ae8516dd83352fe86ca89930a8e337b75a9a0'
AND (
token = 'waTGHEIw4kr8SIrO1+x0eny34fNwKmMp9JTo8FRu6gA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)