UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'huSUzXUXpdrFrJC45UDHeVbOCbIsA31Z+uqEcDDAlhg='
WHERE
key_id = 'dc8cf47321ed2cccc884bab74fa5b16383d4bf8a9bc58ff6c8e90079a48e3b1e'
AND (
token = 'huSUzXUXpdrFrJC45UDHeVbOCbIsA31Z+uqEcDDAlhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)