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