UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p/KFScySU7uAFbFSHifCTiIQGZM7RiztwHhEkgMqa5E='
WHERE
key_id = '8ed64a47f529b322fd0d0d77fb580f824d647b1ae6b36011edcedd1a86d496a5'
AND (
token = 'p/KFScySU7uAFbFSHifCTiIQGZM7RiztwHhEkgMqa5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)