UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bC5+T2nEx0mBhg6YHaBmKRkfjhPeTwtkhNJcAnyU7As='
WHERE
key_id = 'fdf28ea2e45cb06b79f435e30b375210dcbc5a712449f85d6405a9f3e68672a5'
AND (
token = 'bC5+T2nEx0mBhg6YHaBmKRkfjhPeTwtkhNJcAnyU7As='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)