UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm7IHFfYZPYm159POzHiBC8p6h5DrzQxpTd4xjCK6K78='
WHERE
key_id = '4273b05df47b3bc04f59bad186c13ef43e0f16e85184b535b4fb017cbab96127'
AND (
token = 'm7IHFfYZPYm159POzHiBC8p6h5DrzQxpTd4xjCK6K78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)