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