UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v2EVvlpY4bV8tL1Io3EuXSM+7kJUj8vEBiFkiH15OXI='
WHERE
key_id = 'd63396e8a554ca9932775e1c5091e51262cf6b16cee70f2a4a5b33d308154522'
AND (
token = 'v2EVvlpY4bV8tL1Io3EuXSM+7kJUj8vEBiFkiH15OXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)