UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jAPFJS0uZ+to7/ZZhMt4ds+ue6uFNhrO4adnM7trAqE='
WHERE
key_id = '41f278a8b09ce97970c28841bb72a52874e042f0f05a183812d9365dca954a30'
AND (
token = 'jAPFJS0uZ+to7/ZZhMt4ds+ue6uFNhrO4adnM7trAqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)