UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9Z3aCxhocLqFS2hIGm4Wgi+HJouiUJcED33baVswYU='
WHERE
key_id = 'b53816ab4ec77d58f2580f9ef5c42d587913ee9fb8349a7cb6f7384ac8498461'
AND (
token = 'r9Z3aCxhocLqFS2hIGm4Wgi+HJouiUJcED33baVswYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)