UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J/ENeBKVX6cUY3kpLyW99PRfN1nE4cKPR+l6KEWHDdc='
WHERE
key_id = '9f434caac6b83918492b360426390d200a71395166580e651fea3e4aec5cfda4'
AND (
token = 'J/ENeBKVX6cUY3kpLyW99PRfN1nE4cKPR+l6KEWHDdc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)