UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Qp1OBe3MVbnkfGoupOjUXdMi8HEF+O8sp/35ZwAvjI='
WHERE
key_id = '4d151018f327d15f6b247c8a04f30eeca66b53d0692b842cdb0169ad520ed9bd'
AND (
token = '0Qp1OBe3MVbnkfGoupOjUXdMi8HEF+O8sp/35ZwAvjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)