UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mLjZYSpJR93sGRvpYF+CUvPtOV7WEwri32rP60M5S4E='
WHERE
key_id = 'e410a096e7376bc7ae2927a2a32f38dfb8cdaa615588c9b08daa7656fa01733b'
AND (
token = 'mLjZYSpJR93sGRvpYF+CUvPtOV7WEwri32rP60M5S4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)