UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hgN2HIVWOVT8y5OocHJOKGx6MapOmC13RCzVUZMve98='
WHERE
key_id = '64a353762de8f35edf87c6f7c704f223105c76ce3cb19805616c94ec84b47557'
AND (
token = 'hgN2HIVWOVT8y5OocHJOKGx6MapOmC13RCzVUZMve98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)