UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bo1DHF+66Cqa2NM6N88xSZ1Q2optYzvQbf8MGhv79M0='
WHERE
key_id = 'ba4909697883632c1884eb3feecac2f7ba5900e23fd0c7411574607423aeb9ca'
AND (
token = 'bo1DHF+66Cqa2NM6N88xSZ1Q2optYzvQbf8MGhv79M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)