UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NK0Nw6lPFs0qwKWuuOe4KM43yis2uuRpALA8K6QgNUI='
WHERE
key_id = '0c78e12baf71ee067cf8bf7f87fff93a1a1c1470840368d14d8def2622858f33'
AND (
token = 'NK0Nw6lPFs0qwKWuuOe4KM43yis2uuRpALA8K6QgNUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)