UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '++6XzIRiOja2qXpS9H+oHXgbyf/2wklWJ8otq+DLJK0='
WHERE
key_id = 'b9842f5b30bc6c2ac06ffc445c926e00569543b63bab0f078b22025f61e4a206'
AND (
token = '++6XzIRiOja2qXpS9H+oHXgbyf/2wklWJ8otq+DLJK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)