UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8+qohttLiMEPKYa4xpfIPaEE92j3RWkNl3koVFk5db8='
WHERE
key_id = 'bab978165131aee30c28c3d6a0101f814ea2aad0a5a9efb56593ab3f0364dafe'
AND (
token = '8+qohttLiMEPKYa4xpfIPaEE92j3RWkNl3koVFk5db8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)