UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kcQ9OBIfmpvJZ+rT4DrCN5pgcvkHWV/le89+zD4V/oM='
WHERE
key_id = 'c159e4e1ab06de11b5689c6d2d436c298b189f3e176444c60456d99805486975'
AND (
token = 'kcQ9OBIfmpvJZ+rT4DrCN5pgcvkHWV/le89+zD4V/oM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)